﻿CREATE TABLE [dbo].[AlertEmail] (
    [AlertEmailID]               UNIQUEIDENTIFIER NOT NULL,
    [AlertSubscriptionHistoryID] UNIQUEIDENTIFIER NOT NULL,
    [To]                         VARCHAR (256)    NULL,
    [Subject]                    VARCHAR (1024)   NOT NULL,
    [Body]                       VARCHAR (MAX)    NOT NULL,
    [Sent]                       BIT              NOT NULL,
    [BatchID]                    UNIQUEIDENTIFIER NOT NULL,
    [InsertedDate]               DATETIME         NOT NULL
);

